/*
 Navicat Premium Data Transfer

 Source Server         : cabinPlatForm测试
 Source Server Type    : Oracle
 Source Server Version : 110200
 Source Host           : 172.22.30.254:1521
 Source Schema         : CABINAPP

 Target Server Type    : Oracle
 Target Server Version : 110200
 File Encoding         : 65001

 Date: 04/11/2019 14:10:29
*/


-- ----------------------------
-- Table structure for T_OAUTH_CLIENT_DETAILS
-- ----------------------------
DROP TABLE "CABINAPP"."T_OAUTH_CLIENT_DETAILS";
CREATE TABLE "CABINAPP"."T_OAUTH_CLIENT_DETAILS" (
  "ID" NUMBER(11) NOT NULL ,
  "CLIENT_ID" VARCHAR2(48 BYTE) ,
  "RESOURCE_IDS" VARCHAR2(100 BYTE) ,
  "CLIENT_SECRET" VARCHAR2(100 BYTE) ,
  "CLIENT_SECRET_STR" VARCHAR2(200 BYTE) ,
  "SCOPE" VARCHAR2(30 BYTE) ,
  "AUTHORIZED_GRANT_TYPES" VARCHAR2(100 BYTE) ,
  "WEB_SERVER_REDIRECT_URI" VARCHAR2(50 BYTE) ,
  "AUTHORITIES" VARCHAR2(100 BYTE) ,
  "ACCESS_TOKEN_VALIDITY" NUMBER(11) ,
  "REFRESH_TOKEN_VALIDITY" NUMBER(11) ,
  "ADDITIONAL_INFORMATION" VARCHAR2(100 BYTE) ,
  "AUTOAPPROVE" VARCHAR2(20 BYTE) ,
  "STATUS" NUMBER(2) ,
  "IF_LIMIT" NUMBER(10) ,
  "LIMIT_COUNT" NUMBER(10) 
)
TABLESPACE "CABINAPP_DATA"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "CABINAPP"."T_OAUTH_CLIENT_DETAILS"."ID" IS '主键';
COMMENT ON COLUMN "CABINAPP"."T_OAUTH_CLIENT_DETAILS"."CLIENT_ID" IS '应用标识';
COMMENT ON COLUMN "CABINAPP"."T_OAUTH_CLIENT_DETAILS"."RESOURCE_IDS" IS '资源限定串(逗号分割)';
COMMENT ON COLUMN "CABINAPP"."T_OAUTH_CLIENT_DETAILS"."CLIENT_SECRET" IS '应用密钥(bcyt) 加密';
COMMENT ON COLUMN "CABINAPP"."T_OAUTH_CLIENT_DETAILS"."CLIENT_SECRET_STR" IS '应用密钥(明文)';
COMMENT ON COLUMN "CABINAPP"."T_OAUTH_CLIENT_DETAILS"."SCOPE" IS '范围';
COMMENT ON COLUMN "CABINAPP"."T_OAUTH_CLIENT_DETAILS"."AUTHORIZED_GRANT_TYPES" IS '5种oauth授权方式(authorization_code,password,refresh_token,client_credentials)';
COMMENT ON COLUMN "CABINAPP"."T_OAUTH_CLIENT_DETAILS"."WEB_SERVER_REDIRECT_URI" IS '回调地址';
COMMENT ON COLUMN "CABINAPP"."T_OAUTH_CLIENT_DETAILS"."AUTHORITIES" IS '权限';
COMMENT ON COLUMN "CABINAPP"."T_OAUTH_CLIENT_DETAILS"."ACCESS_TOKEN_VALIDITY" IS 'access_token有效期';
COMMENT ON COLUMN "CABINAPP"."T_OAUTH_CLIENT_DETAILS"."REFRESH_TOKEN_VALIDITY" IS 'refresh_token有效期';
COMMENT ON COLUMN "CABINAPP"."T_OAUTH_CLIENT_DETAILS"."AUTOAPPROVE" IS '是否自动授权 是-true';

-- ----------------------------
-- Records of "T_OAUTH_CLIENT_DETAILS"
-- ----------------------------
INSERT INTO "CABINAPP"."T_OAUTH_CLIENT_DETAILS" VALUES ('1', 'app', NULL, '$2a$10$i3F515wEDiB4Gvj9ym9Prui0dasRttEUQ9ink4Wpgb4zEDCAlV8zO', NULL, 'app', 'password,refresh_token', NULL, NULL, '180000', NULL, '{}', 'true', '0', '0', '10000');
INSERT INTO "CABINAPP"."T_OAUTH_CLIENT_DETAILS" VALUES ('2', 'mobile', 'mobile,test', '$2a$10$ULxRssv/4NWOc388lZFbyus3IFfsbcpG/BZOq4TRxDhsx5HHIR7Jm', NULL, 'all', 'password,refresh_token', NULL, NULL, '180000', NULL, '{}', 'true', '0', '0', '10000');
INSERT INTO "CABINAPP"."T_OAUTH_CLIENT_DETAILS" VALUES ('4', 'webApp', NULL, '$2a$10$06msMGYRH8nrm4iVnKFNKOoddB8wOwymVhbUzw/d3ZixD7Nq8ot72', NULL, 'app', 'authorization_code,password,refresh_token,client_credentials', NULL, NULL, '180000', NULL, '{}', 'true', '1', '0', '10000');

-- ----------------------------
-- Table structure for T_OAUTH_CLIENT_SERVICE
-- ----------------------------
DROP TABLE "CABINAPP"."T_OAUTH_CLIENT_SERVICE";
CREATE TABLE "CABINAPP"."T_OAUTH_CLIENT_SERVICE" (
  "CLIENTID" NUMBER(11) NOT NULL ,
  "SERVICEID" NUMBER(11) NOT NULL 
)
TABLESPACE "CABINAPP_DATA"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "CABINAPP"."T_OAUTH_CLIENT_SERVICE"."CLIENTID" IS '应用标识';
COMMENT ON COLUMN "CABINAPP"."T_OAUTH_CLIENT_SERVICE"."SERVICEID" IS '服务权限标识';

-- ----------------------------
-- Records of "T_OAUTH_CLIENT_SERVICE"
-- ----------------------------
INSERT INTO "CABINAPP"."T_OAUTH_CLIENT_SERVICE" VALUES ('4', '74');
INSERT INTO "CABINAPP"."T_OAUTH_CLIENT_SERVICE" VALUES ('4', '75');
INSERT INTO "CABINAPP"."T_OAUTH_CLIENT_SERVICE" VALUES ('4', '76');
INSERT INTO "CABINAPP"."T_OAUTH_CLIENT_SERVICE" VALUES ('4', '78');
INSERT INTO "CABINAPP"."T_OAUTH_CLIENT_SERVICE" VALUES ('4', '79');
INSERT INTO "CABINAPP"."T_OAUTH_CLIENT_SERVICE" VALUES ('4', '80');
INSERT INTO "CABINAPP"."T_OAUTH_CLIENT_SERVICE" VALUES ('4', '81');
INSERT INTO "CABINAPP"."T_OAUTH_CLIENT_SERVICE" VALUES ('4', '82');
INSERT INTO "CABINAPP"."T_OAUTH_CLIENT_SERVICE" VALUES ('4', '83');
INSERT INTO "CABINAPP"."T_OAUTH_CLIENT_SERVICE" VALUES ('4', '84');
INSERT INTO "CABINAPP"."T_OAUTH_CLIENT_SERVICE" VALUES ('4', '85');
INSERT INTO "CABINAPP"."T_OAUTH_CLIENT_SERVICE" VALUES ('4', '86');
INSERT INTO "CABINAPP"."T_OAUTH_CLIENT_SERVICE" VALUES ('4', '87');
INSERT INTO "CABINAPP"."T_OAUTH_CLIENT_SERVICE" VALUES ('4', '88');
INSERT INTO "CABINAPP"."T_OAUTH_CLIENT_SERVICE" VALUES ('4', '89');
INSERT INTO "CABINAPP"."T_OAUTH_CLIENT_SERVICE" VALUES ('4', '90');
INSERT INTO "CABINAPP"."T_OAUTH_CLIENT_SERVICE" VALUES ('4', '91');

-- ----------------------------
-- Table structure for T_OAUTH_SERVICE
-- ----------------------------
DROP TABLE "CABINAPP"."T_OAUTH_SERVICE";
CREATE TABLE "CABINAPP"."T_OAUTH_SERVICE" (
  "ID" NUMBER(11) NOT NULL ,
  "PARENTID" NUMBER(11) ,
  "NAME" VARCHAR2(64 BYTE) ,
  "URL" VARCHAR2(100 BYTE) ,
  "PATH" VARCHAR2(100 BYTE) ,
  "CSS" VARCHAR2(32 BYTE) ,
  "SORT" NUMBER(11) ,
  "CREATETIME" DATE ,
  "UPDATETIME" DATE ,
  "ISMENU" NUMBER(11) 
)
TABLESPACE "CABINAPP_DATA"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "CABINAPP"."T_OAUTH_SERVICE"."ISMENU" IS '''是否服务 1 是 2 不是'',';

-- ----------------------------
-- Records of "T_OAUTH_SERVICE"
-- ----------------------------
INSERT INTO "CABINAPP"."T_OAUTH_SERVICE" VALUES ('74', '-1', '认证中心', NULL, '/api-auth', NULL, '1', TO_DATE('2019-04-09 12:37:57', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-11-02 23:43:22', 'SYYYY-MM-DD HH24:MI:SS'), '1');
INSERT INTO "CABINAPP"."T_OAUTH_SERVICE" VALUES ('75', '74', '应用管理', NULL, '/api-user/client**/**', NULL, '1', TO_DATE('2019-04-09 12:38:54', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-04-09 12:38:54', 'SYYYY-MM-DD HH24:MI:SS'), '1');
INSERT INTO "CABINAPP"."T_OAUTH_SERVICE" VALUES ('76', '74', '认证管理', NULL, '/api-auth/oauth**/**', NULL, '2', TO_DATE('2019-04-09 12:39:21', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-27 01:18:38', 'SYYYY-MM-DD HH24:MI:SS'), '1');
INSERT INTO "CABINAPP"."T_OAUTH_SERVICE" VALUES ('77', '74', 'redis监控', NULL, '/api-auth/redis**/**', NULL, '3', TO_DATE('2019-04-09 12:40:10', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-04-09 12:40:10', 'SYYYY-MM-DD HH24:MI:SS'), '1');
INSERT INTO "CABINAPP"."T_OAUTH_SERVICE" VALUES ('78', '74', '服务管理', NULL, '/api-auth/services**/**', NULL, '4', TO_DATE('2019-04-09 12:40:41', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-04-09 12:40:41', 'SYYYY-MM-DD HH24:MI:SS'), '1');
INSERT INTO "CABINAPP"."T_OAUTH_SERVICE" VALUES ('79', '-1', '用户中心', NULL, '/api-user', NULL, '2', TO_DATE('2019-04-09 12:41:43', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-04-09 12:41:43', 'SYYYY-MM-DD HH24:MI:SS'), '1');
INSERT INTO "CABINAPP"."T_OAUTH_SERVICE" VALUES ('80', '79', '用户管理', NULL, '/api-user/users**/**', NULL, '1', TO_DATE('2019-04-09 12:42:21', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-27 01:21:03', 'SYYYY-MM-DD HH24:MI:SS'), '1');
INSERT INTO "CABINAPP"."T_OAUTH_SERVICE" VALUES ('81', '79', '角色管理', NULL, '/api-user/roles**/**', NULL, '2', TO_DATE('2019-04-09 12:42:57', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-04-09 12:42:57', 'SYYYY-MM-DD HH24:MI:SS'), '1');
INSERT INTO "CABINAPP"."T_OAUTH_SERVICE" VALUES ('82', '79', '菜单管理', NULL, '/api-user/menus**/**', NULL, '3', TO_DATE('2019-04-09 12:43:25', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-04-09 12:43:25', 'SYYYY-MM-DD HH24:MI:SS'), '1');
INSERT INTO "CABINAPP"."T_OAUTH_SERVICE" VALUES ('83', '79', '权限管理', NULL, '/api-user/permissions**/**', NULL, '4', TO_DATE('2019-04-09 12:43:57', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-04-09 12:43:57', 'SYYYY-MM-DD HH24:MI:SS'), '1');
INSERT INTO "CABINAPP"."T_OAUTH_SERVICE" VALUES ('84', '-1', '文件中心', NULL, '/api-file', NULL, '3', TO_DATE('2019-04-09 12:44:22', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-04-09 12:44:22', 'SYYYY-MM-DD HH24:MI:SS'), '1');
INSERT INTO "CABINAPP"."T_OAUTH_SERVICE" VALUES ('85', '84', '文件管理', NULL, '/api-file/files**/**', NULL, '1', TO_DATE('2019-04-09 12:45:17', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-04-09 12:45:17', 'SYYYY-MM-DD HH24:MI:SS'), '1');
INSERT INTO "CABINAPP"."T_OAUTH_SERVICE" VALUES ('86', '-1', '短信中心', NULL, '/api/sms', NULL, '4', TO_DATE('2019-04-09 12:45:40', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-04-09 12:45:40', 'SYYYY-MM-DD HH24:MI:SS'), '1');
INSERT INTO "CABINAPP"."T_OAUTH_SERVICE" VALUES ('87', '86', '短信管理', NULL, '/api/sms/sms**/**', NULL, '1', TO_DATE('2019-04-09 12:46:28', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-04-09 12:46:28', 'SYYYY-MM-DD HH24:MI:SS'), '1');
INSERT INTO "CABINAPP"."T_OAUTH_SERVICE" VALUES ('88', '-1', '日志中心', NULL, '/api-log', NULL, '5', TO_DATE('2019-04-09 12:47:11', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-04-09 12:47:11', 'SYYYY-MM-DD HH24:MI:SS'), '1');
INSERT INTO "CABINAPP"."T_OAUTH_SERVICE" VALUES ('89', '88', '日志管理', NULL, '/api-log/sysLog**/**', NULL, '1', TO_DATE('2019-04-09 12:47:31', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-04-09 12:47:31', 'SYYYY-MM-DD HH24:MI:SS'), '1');
INSERT INTO "CABINAPP"."T_OAUTH_SERVICE" VALUES ('90', '-1', '注册中心', NULL, '/api-eureka', NULL, '6', TO_DATE('2019-04-09 21:25:10', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-04-09 21:25:10', 'SYYYY-MM-DD HH24:MI:SS'), '1');
INSERT INTO "CABINAPP"."T_OAUTH_SERVICE" VALUES ('91', '90', '服务治理', '/api-eureka/eureka**/**', '/api-eureka/eureka**/**', NULL, '1', TO_DATE('2019-04-09 21:25:53', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-04-09 21:29:53', 'SYYYY-MM-DD HH24:MI:SS'), '1');

-- ----------------------------
-- Table structure for T_OA_USER
-- ----------------------------
DROP TABLE "CABINAPP"."T_OA_USER";
CREATE TABLE "CABINAPP"."T_OA_USER" (
  "ID" NVARCHAR2(255) ,
  "PK_PSNBASDOC" NVARCHAR2(255) ,
  "BIRTHDATE" DATE ,
  "PSNNAME" NVARCHAR2(255) ,
  "OFFICEPHONE" NVARCHAR2(255) ,
  "MOBILE" NVARCHAR2(255) ,
  "SEX" NVARCHAR2(255) ,
  "JOINSYSDATE" DATE ,
  "JOINPOLITYDATE" NVARCHAR2(255) ,
  "FROEIGNLANG" NVARCHAR2(255) ,
  "FROLANLEVEL" NVARCHAR2(255) ,
  "PSNNAMEPINYIN" NVARCHAR2(255) ,
  "PSNCODE" NVARCHAR2(255) ,
  "CLERKCODE" NVARCHAR2(255) ,
  "DOMAIN_ID" NVARCHAR2(255) ,
  "EMAIL" NVARCHAR2(255) ,
  "PK_DEPTDOC" NVARCHAR2(255) ,
  "DEPT_DETAIL" NVARCHAR2(255) ,
  "PK_OM_JOB" NVARCHAR2(255) ,
  "JOBNAME" NVARCHAR2(255) ,
  "PK_PSNCL" NVARCHAR2(255) ,
  "POSTSTAT" NVARCHAR2(255) ,
  "JOBRANK" NVARCHAR2(255) ,
  "JOBRANK_NAME" NVARCHAR2(255) ,
  "JOBRANK_CODE" NVARCHAR2(255) ,
  "JOBSERIES" NVARCHAR2(255) ,
  "PK_WORK_PLACE" NVARCHAR2(255) ,
  "PK_PROTOCOL" NVARCHAR2(255) ,
  "PK_PSNDOC" NVARCHAR2(255) ,
  "PSNCLSCOPE" NVARCHAR2(255) ,
  "PK_DUTYRANK" NVARCHAR2(255) ,
  "USER_CODE" NVARCHAR2(255) ,
  "USER_NAME" NVARCHAR2(255) ,
  "PSNCLASSCODE" NVARCHAR2(255) ,
  "PHOTO" NVARCHAR2(255) ,
  "PK_TECHNICAL_LEVEL" NVARCHAR2(255) ,
  "INDUTYDATE" DATE ,
  "USEDNAME" NVARCHAR2(255) ,
  "BLOODTYPE" NVARCHAR2(255) ,
  "COUNTRY" NVARCHAR2(255) ,
  "NATIVEPLACE" NVARCHAR2(255) ,
  "NATIONALITY" NVARCHAR2(255) ,
  "EDUCATION" NVARCHAR2(255) ,
  "EDUDEGREE" NVARCHAR2(255) ,
  "MAJOR" NVARCHAR2(255) ,
  "JOINWORKDATE" NVARCHAR2(255) ,
  "HOMEPHONE" NVARCHAR2(255) ,
  "IDTYPE" NVARCHAR2(255) ,
  "MARITAL" NVARCHAR2(255) ,
  "HEALTH" NVARCHAR2(255) ,
  "CHARACTERRPR" NVARCHAR2(255) ,
  "PERMANRESIDE" NVARCHAR2(255) ,
  "ADDR" NVARCHAR2(255) ,
  "CURADDRESS" NVARCHAR2(255) ,
  "POSTALCODE" NVARCHAR2(255) ,
  "EMGCCONTACT" NVARCHAR2(255) ,
  "EMGCCONTACTPHONE" NVARCHAR2(255) ,
  "QQ" NVARCHAR2(255) ,
  "EMP_WECHAT" NVARCHAR2(255) ,
  "INSOURCE" NVARCHAR2(255) ,
  "REGULARDATA" NVARCHAR2(255) ,
  "MAJOR_RANK" NVARCHAR2(255) ,
  "WORK_PLACE" NVARCHAR2(255) ,
  "PROTOCAL_BELONG" NVARCHAR2(255) ,
  "EMPLOEE_RANK" NVARCHAR2(255) ,
  "JOIN_JX_DATE" DATE ,
  "EMPLOYFORM" NVARCHAR2(255) ,
  "BEFJOIN_WORKYEAR" NVARCHAR2(255) ,
  "ACCUM_FUND_ACCOUNT" NVARCHAR2(255) ,
  "PK_CORP" NVARCHAR2(255) ,
  "TS" DATE ,
  "ISVALID" NVARCHAR2(255) ,
  "IS_POSITION" NVARCHAR2(255) ,
  "IS_EMP_MAN" NVARCHAR2(255) ,
  "IS_DELETED" NVARCHAR2(255) ,
  "ROW_NUM" NVARCHAR2(255) ,
  "EMPLOEE_RANK_NAME" NVARCHAR2(255) ,
  "SAFE_LEVEL" NVARCHAR2(255) ,
  "PK_BELONG_DEPT" NVARCHAR2(255) ,
  "DEPTNAME" NVARCHAR2(255) ,
  "PHOTO_URL" NVARCHAR2(255) ,
  "PK_CORP_FIANCE" NVARCHAR2(255) 
)
TABLESPACE "CABINAPP_DATA"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of "T_OA_USER"
-- ----------------------------
INSERT INTO "CABINAPP"."T_OA_USER" VALUES ('1', '0001A51000000005G8SR', TO_DATE('1991-06-11 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), '任翊慈', '886255690666', '886913139030', '女', TO_DATE('2014-03-17 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, 'lycryc', 'HO-0006323', 'HO00-0005777', 'renyici', 'renyici@junyao.com', '1044A51000000019EH5R', '董事会/总裁室/商务部/销售处/台湾台北营业部（已封存）', '1044A51000000019GOIZ', '航线销售专员', '0001AA10000000000BMT', 'N', '0001V61000000001K6V2', 'E层级', '5', '0001V61000000001K6VH', '0001A51000000005L140', '0001A51000000005KZEV', '0001A51000000005G8SS', '2', '0001A51000000005KWIM', NULL, NULL, '201', '�က䙊䙉Āā怀怀', NULL, TO_DATE('2014-03-17 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, 'HI200000000000002008', NULL, 'HI200000000000000301', 'HI300000000000000072', '0001V61000000001K6UM', '中国语文学系', '2014-03-17', '+886913139030', '0001A5100000000588SH', 'HI300000000000000111', 'HI300000000000000101', NULL, NULL, '台湾省台北市大安区基隆路二段166号16-1', '台湾省台北市大安区基隆路二段166号16-1', '10675', '范秉兆', '0935511572', NULL, NULL, '0001A51000000005T8GX', '2014-06-16', NULL, '0001A51000000005L140', '0001A51000000005KZEV', '0001A51000000005KWIM', NULL, NULL, NULL, NULL, '1044', TO_DATE('2018-09-25 18:00:00', 'SYYYY-MM-DD HH24:MI:SS'), 'N', 'N', 'N', 'N', '1', '基础层', '3', '1044AA1000000000007D', '台湾台北营业部（已封存）', NULL, NULL);
INSERT INTO "CABINAPP"."T_OA_USER" VALUES ('2', '0001V11000000002WEZD', TO_DATE('1950-04-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), 'James', NULL, '13661917064', '男', NULL, NULL, NULL, NULL, 'James', '0002998', 'JH00-0002998', 'jdonch', 'jdonch@aol.com', '1044A2100000000FHXOW', '董事会/总裁室/飞行部/三分部(外籍)（已撤销）', NULL, NULL, '0001AA10000000000BMT', 'N', NULL, NULL, NULL, NULL, '0001A51000000005KZI6', NULL, '0001V11000000002WEZE', '2', NULL, NULL, NULL, '201', NULL, NULL, TO_DATE('2007-09-21 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, NULL, 'HI200000000000000397', 'HI300000000000000072', '0001V61000000001K6UM', NULL, '1972-01-01', '-', NULL, 'HI300000000000000114', 'HI300000000000000101', 'HI700000000000002701', 'HRPMPLYA000000000000', '-', '-', NULL, 'Lori Donch', '12105737061', NULL, NULL, '0001A51000000005T8GX', NULL, NULL, '0001A51000000005KZI6', NULL, NULL, NULL, NULL, NULL, NULL, '1044', TO_DATE('2019-01-10 18:00:18', 'SYYYY-MM-DD HH24:MI:SS'), 'N', 'N', 'N', 'N', '1', NULL, '6', '1044AA1000000000006U', '三分部(外籍)（已撤销）', NULL, NULL);
INSERT INTO "CABINAPP"."T_OA_USER" VALUES ('3', '1044AA100000000001HR', TO_DATE('1980-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), '刘凯宇', NULL, '--', '男', NULL, NULL, NULL, NULL, 'lky', '0001729', 'JH00-0000321', NULL, 'liukaiyu@junyao.com', '1044AA1000000000007A', '董事会/总裁室/维修工程部', NULL, NULL, '0001AA10000000000BMT', 'N', NULL, NULL, NULL, NULL, '0001A51000000005KZI6', NULL, '1044AA100000000001HR', '2', NULL, NULL, NULL, '201', NULL, NULL, TO_DATE('2006-03-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, 'HRPMPLYA000000000023', 'HI200000000000000301', 'HI300000000000000072', '0001V61000000001K6UM', NULL, '1980-01-01', '--', NULL, 'HI300000000000000112', 'HI300000000000000101', 'HI700000000000002701', 'HRPMPLYA000000000000', '--', '--', NULL, '--', '--', NULL, NULL, '0001A51000000005T8GX', NULL, NULL, '0001A51000000005KZI6', NULL, NULL, NULL, NULL, NULL, NULL, '1044', TO_DATE('2019-03-07 16:04:30', 'SYYYY-MM-DD HH24:MI:SS'), 'N', 'N', 'N', 'N', '1', NULL, '3', '1044AA1000000000007A', '维修工程部', NULL, NULL);
INSERT INTO "CABINAPP"."T_OA_USER" VALUES ('4', '0001A510000000059KXN', TO_DATE('1963-11-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), '甘国秀', NULL, '18516045787', '男', NULL, NULL, NULL, NULL, 'ggxhgx', 'HO-0002488', 'HO00-0005333', 'ganguoxiu', 'ganguoxiu@juneyaoair.com', '1044A510000000U38WYX', '董事会/总裁室/飞行部/飞行六/七分部', '1044A510000000YQ0TH1', '飞行员', '0001V61000000001K6TK', 'Y', '0001V61000000001K6V2', 'E层级', '5', '0001V61000000001K6VX', '0001A51000000005KZI6', '0001A51000000005KZF8', '0001A510000000059KXO', '0', NULL, NULL, NULL, '105', '�က䙊䙉Āā怀怀', '0001A510000000069H3E', TO_DATE('2013-07-15 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, 'HI200000000000002008', NULL, 'HI200000000000000397', 'HI300000000000000071', 'HI300000000000000084', '法律', '2013-07-15', '-', '0001A5100000000588SJ', 'HI300000000000000112', 'HI300000000000000101', NULL, 'HRPMPLYA000000003404', '深圳市南山区南光路166号中洞大厦A1405', '深圳市南山区南光路166号中洞大厦A1405', NULL, '-', '-', NULL, NULL, '0001A51000000005T8GX', '2013-07-15', '0001A510000000069H3E', '0001A51000000005KZI6', '0001A51000000005KZF8', '0001A51000000005KWIL', TO_DATE('2013-07-15 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '1044', TO_DATE('2019-08-30 16:21:00', 'SYYYY-MM-DD HH24:MI:SS'), 'Y', 'N', 'N', 'N', '1', '骨干层', '6', '1044AA1000000000006U', '飞行六/七分部', 'ganguoxiu.jpg', NULL);
INSERT INTO "CABINAPP"."T_OA_USER" VALUES ('5', '0001A51000000006YO9G', TO_DATE('1988-02-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), '张若婷', NULL, '18616341952', '女', TO_DATE('2017-02-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, 'zrt', 'HO-0011584', 'HO00-0009694', 'zhangruoting', 'zhangruoting@juneyaoair.com', '1044A51000000013PHB7', '董事会/总裁室/客舱部/乘务分部', '1044A51000000013PJZ4', '乘务员', '0001V61000000001K6TC', 'Y', '0001V61000000001K6V2', 'E层级', '5', '0001V61000000001K6VS', '0001A51000000005KZI6', '0001A51000000005KZEV', '0001A51000000006YO9H', '0', NULL, NULL, NULL, '101', '�က䙊䙉ĀĀĀ', NULL, TO_DATE('2017-02-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, 'HI200000000000002008', NULL, 'HI200000000000000301', 'HI300000000000000072', NULL, '财法系', '2010-08-01', NULL, '0001A5100000000588SJ', 'HI300000000000000111', 'HI300000000000000101', NULL, 'HRPMPLYA000000003404', '台湾省新北市永和区光明里001邻中正路666巷64号', '台湾省新北市永和区光明里001邻中正路666巷64号', NULL, '张庆松', '886988348963', NULL, NULL, '0001A51000000005T8GX', '2017-08-13', '0001A51000000007DKS6', '0001A51000000005KZI6', '0001A51000000005KZEV', '0001A51000000005KWIM', TO_DATE('2017-02-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '1044', TO_DATE('2019-07-30 15:21:37', 'SYYYY-MM-DD HH24:MI:SS'), 'Y', 'N', 'N', 'N', '1', '基础层', '3', '1044AA1000000000006X', '乘务分部', 'zhangruoting.jpg', NULL);
INSERT INTO "CABINAPP"."T_OA_USER" VALUES ('6', '0001A51000000005DTGU', TO_DATE('1960-08-05 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), '孙瑞民', NULL, '15601980935', '男', NULL, NULL, NULL, NULL, 'xrmsrm', 'HO-0006001', 'HO00-0005675', 'sunruimin', 'sunruimin@juneyaoair.com', '1044A510000000U38WYX', '董事会/总裁室/飞行部/飞行六/七分部', '1044A510000000YQ0TH1', '飞行员', '0001V61000000001K6TK', 'Y', '0001V61000000001K6V2', 'E层级', '5', '0001V61000000001K6VX', '0001A51000000005KZI6', '0001A51000000005KZF8', '0001A51000000005DTGV', '0', NULL, NULL, NULL, '105', '�က䙊䙉Āā怀怀', NULL, TO_DATE('2013-12-20 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, 'HI200000000000002008', NULL, 'HI200000000000000397', 'HI300000000000000072', '0001V61000000001K6UM', '航空工程系', '2014-01-17', '-', '0001A5100000000588SH', 'HI300000000000000114', 'HI300000000000000101', NULL, 'HRPMPLYA000000003404', '台湾台北市松山区市民大道5段155号6F', '台湾台北市松山区市民大道5段155号6F', NULL, '孙振威', '-', NULL, NULL, '0001A51000000005T8GX', '2014-01-17', '0001A510000000069H3D', '0001A51000000005KZI6', '0001A51000000005KZF8', '0001A51000000005KWIL', TO_DATE('2013-12-20 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '1044', TO_DATE('2019-08-30 16:20:30', 'SYYYY-MM-DD HH24:MI:SS'), 'Y', 'N', 'N', 'N', '1', '骨干层', '6', '1044AA1000000000006U', '飞行六/七分部', 'sunruimin.jpg', NULL);
INSERT INTO "CABINAPP"."T_OA_USER" VALUES ('7', '0001A51000000006CHQQ', TO_DATE('1966-10-08 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), '阎骏', NULL, '13166100968', '男', NULL, NULL, NULL, NULL, 'yj', 'HO-0010386', 'HO00-0008629', 'yjun6', 'yjun6@juneyaoair.com', '1044A510000000U38WYX', '董事会/总裁室/飞行部/飞行六/七分部', '1044A510000000YQ0TH1', '飞行员', '0001V61000000001K6TK', 'Y', '0001V61000000001K6V2', 'E层级', '5', '0001V61000000001K6VX', '0001A51000000005KZI6', '0001A51000000005KZF8', '0001A51000000006CHQR', '0', NULL, NULL, NULL, '105', NULL, NULL, TO_DATE('2016-06-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, 'HI200000000000002008', 'HRPMPLYA000000003404', 'HI200000000000000301', 'HI300000000000000072', NULL, '电机', '1991-09-01', NULL, '0001A5100000000588SJ', 'HI300000000000000112', 'HI300000000000000101', NULL, NULL, '台北市北投区石牌路343巷5号3楼', '台北市北投区石牌路343巷5号3楼', NULL, '黄明珠', '（886）939370710', NULL, NULL, '0001A51000000005T8H4', '2016-06-27', '0001A510000000069H3D', '0001A51000000005KZI6', '0001A51000000005KZF8', '0001A51000000005KWIL', TO_DATE('2016-06-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '1044', TO_DATE('2019-02-01 03:39:57', 'SYYYY-MM-DD HH24:MI:SS'), 'Y', 'N', 'N', 'N', '1', '骨干层', '6', '1044AA1000000000006U', '飞行六/七分部', NULL, NULL);
INSERT INTO "CABINAPP"."T_OA_USER" VALUES ('8', '0001A510000000059C30', TO_DATE('1960-11-22 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), 'MICHAELHOWARDEDELMAN', NULL, '13816841962', '男', TO_DATE('2010-04-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, 'MICHAELHOWARDEDELMAN', 'HO-0001521', 'HO00-0001583', NULL, '0', '1044A2100000000FHXOW', '董事会/总裁室/飞行部/三分部(外籍)（已撤销）', '1044A8100000000S5YLK', '飞行员', '0001AA10000000000BMT', 'N', '0001V61000000001K6V2', 'E层级', '5', '0001V61000000001K6VX', '0001A51000000005KZI6', NULL, '0001A510000000059C31', '2', NULL, NULL, NULL, '201', NULL, NULL, TO_DATE('2010-04-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, 'HI200000000000002010', NULL, 'HI200000000000000397', 'HI300000000000000072', '0001V61000000001K6UN', NULL, '2010-04-14', '0', '0001A5100000000588SH', 'HI300000000000000112', 'HI300000000000000101', NULL, '0001A510000000059CFD', '上海市虹梅路3318弄12号301室', '上海市虹梅路3318弄12号301室', NULL, '0', '0', NULL, NULL, '0001A51000000005T8GX', NULL, '0001A510000000069H38', '0001A51000000005KZI6', NULL, '0001A51000000005KWIL', NULL, NULL, NULL, NULL, '1044', TO_DATE('2019-01-10 18:00:18', 'SYYYY-MM-DD HH24:MI:SS'), 'N', 'N', 'N', 'N', '1', '骨干层', '6', '1044AA1000000000006U', '三分部(外籍)（已撤销）', NULL, NULL);
INSERT INTO "CABINAPP"."T_OA_USER" VALUES ('9', '0001A2100000000331XI', TO_DATE('1963-01-31 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), 'Bradley', NULL, '13918656674', '男', TO_DATE('2008-04-29 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, 'Bradley', '0003448', 'JH00-0003448', NULL, '-', '1044A2100000000FHXOW', '董事会/总裁室/飞行部/三分部(外籍)（已撤销）', NULL, NULL, '0001AA10000000000BMT', 'N', NULL, NULL, NULL, NULL, '0001A51000000005KZI6', '0001A51000000005KZEQ', '0001A2100000000331XJ', '2', NULL, NULL, NULL, '201', NULL, NULL, TO_DATE('2008-04-29 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, 'HI200000000000002002', NULL, 'HI200000000000000397', 'HI300000000000000072', '0001V61000000001K6UN', NULL, '1990-01-01', '-', NULL, 'HI300000000000000112', 'HI300000000000000101', NULL, 'HRPMPLYA000000003405', '-', '-', NULL, '-', '-', NULL, NULL, '0001A51000000005T8GX', NULL, NULL, '0001A51000000005KZI6', '0001A51000000005KZEQ', '0001A51000000005KWIM', NULL, NULL, NULL, NULL, '1044', TO_DATE('2019-03-07 17:55:45', 'SYYYY-MM-DD HH24:MI:SS'), 'N', 'N', 'N', 'N', '1', '基础层', '6', '1044AA1000000000006U', '三分部(外籍)（已撤销）', NULL, NULL);
INSERT INTO "CABINAPP"."T_OA_USER" VALUES ('10', '0001A51000000006HRUA', TO_DATE('1968-01-13 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), '张济华', NULL, '18516293851', '男', NULL, NULL, NULL, NULL, 'zqhzjh', 'HO-0011084', 'HO00-0009249', 'zhangjihua', 'zhangjihua@juneyaoair.com', '1044A510000000331GBJ', '董事会/总裁室/江苏分公司/飞行运行控制部（江苏）', '1044A5100000008KBKZV', '飞行员', '0001V61000000001K6TK', 'Y', '0001V61000000001K6V2', 'E层级', '5', '0001V61000000001K6VX', '0001A510000000065LC1', '0001A51000000005KZF8', '0001A51000000006HRUB', '0', NULL, NULL, NULL, '105', NULL, NULL, TO_DATE('2016-08-31 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, 'HI200000000000002008', 'HRPMPLYA000000003404', NULL, 'HI300000000000000071', NULL, '航空太空工程', '1997-10-01', NULL, '0001A5100000000588SJ', 'HI300000000000000112', 'HI300000000000000101', NULL, 'HRPMPLYA000000003404', '台湾新北市汐止区忠三街39巷41弄38号', '台湾新北市汐止区忠三街39巷41弄38号', NULL, '张王锦', '886905781727', NULL, NULL, '0001A51000000005T8H4', '2016-08-31', '0001A510000000069H3D', '0001A510000000065LC1', '0001A51000000005KZF8', '0001A51000000005KWIL', TO_DATE('2016-08-31 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '1044', TO_DATE('2019-06-18 21:25:22', 'SYYYY-MM-DD HH24:MI:SS'), 'Y', 'N', 'N', 'N', '1', '骨干层', '3', '1044A510000000331G9V', '飞行运行控制部（江苏）', NULL, '1099');
INSERT INTO "CABINAPP"."T_OA_USER" VALUES ('11', '1044A51000000013UFYU', TO_DATE('1966-08-24 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), 'Wilmer Jose SANCHEZ MANTILLA', NULL, '58-414-2761774', '男', TO_DATE('2013-01-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, 'Wilmer Jose SANCHEZ MANTILLA', 'HO-0002077', 'HO00-0004932', NULL, '-', '1044A2100000000FHXOW', '董事会/总裁室/飞行部/三分部(外籍)（已撤销）', '1044A8100000000S5YLK', '飞行员', '0001AA10000000000BMT', 'N', '0001V61000000001K6V2', 'E层级', '5', '0001V61000000001K6VX', '0001A51000000005KZI6', NULL, '1044A51000000013UHD9', '2', NULL, NULL, NULL, '201', NULL, NULL, TO_DATE('2013-01-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, 'HI200000000000002862', NULL, 'HI200000000000000397', 'HI300000000000000072', '0001V61000000001K6UN', NULL, '2013-01-09', '58-212-7518492', '0001A5100000000588SJ', 'HI300000000000000112', 'HI300000000000000101', NULL, '0001A510000000059CFD', '-', '-', NULL, '-', '-', NULL, NULL, '0001A51000000005T8GX', NULL, NULL, '0001A51000000005KZI6', NULL, NULL, NULL, NULL, NULL, NULL, '1044', TO_DATE('2019-01-10 18:00:18', 'SYYYY-MM-DD HH24:MI:SS'), 'N', 'N', 'N', 'N', '1', NULL, '6', '1044AA1000000000006U', '三分部(外籍)（已撤销）', NULL, NULL);
INSERT INTO "CABINAPP"."T_OA_USER" VALUES ('12', '0001A51000000005S3RP', TO_DATE('1961-08-06 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), '邹台生', NULL, '15021877150', '男', NULL, NULL, NULL, NULL, 'jysjtsjsszysztszss', 'HO-0008176', 'HO00-0007230', 'zoutaisheng', 'zoutaisheng@juneyaoair.com', '1044A510000000U38WYX', '董事会/总裁室/飞行部/飞行六/七分部', '1044A510000000YQ0TH1', '飞行员', '0001V61000000001K6TK', 'Y', '0001V61000000001K6V2', 'E层级', '5', '0001V61000000001K6VX', '0001A51000000005KZI6', '0001A51000000005KZF8', '0001A51000000005S3RQ', '0', NULL, NULL, NULL, '105', NULL, NULL, TO_DATE('2015-06-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, 'HI200000000000002008', NULL, 'HI200000000000000397', 'HI300000000000000072', NULL, '学士', '1993-05-01', '+886 2 28210328', '0001A5100000000588SJ', 'HI300000000000000112', 'HI300000000000000101', NULL, 'HRPMPLYA000000003404', '台湾省台北市業華一路4巷3号', '台湾省台北市業華一路4巷3号', NULL, '张美雪', '886 928272468', NULL, NULL, '0001A51000000005T8GX', NULL, '0001A510000000069H3C', '0001A51000000005KZI6', '0001A51000000005KZF8', '0001A51000000005KWIL', TO_DATE('2015-06-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, '1044', TO_DATE('2019-08-30 16:05:34', 'SYYYY-MM-DD HH24:MI:SS'), 'Y', 'N', 'N', 'N', '1', '骨干层', '6', '1044AA1000000000006U', '飞行六/七分部', NULL, NULL);
INSERT INTO "CABINAPP"."T_OA_USER" VALUES ('13', '1044A51000000013UFYW', TO_DATE('1965-09-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), 'Luis Manuel Hernandez Liendo', NULL, '13816617344', '男', TO_DATE('2012-12-12 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL, 'Luis Manuel Hernandez Liendo', 'HO-0002067', 'HO00-0004886', NULL, '-', '1044A2100000000FHXOW', '董事会/总裁室/飞行部/三分部(外籍)（已撤销）', '1044A8100000000S5YLK', '飞行员', '0001AA10000000000BMT', 'N', '0001V61000000001K6V2', 'E层级', '5', '0001V61000000001K6VX', '0001A51000000005KZI6', NULL, '1044A51000000013UHSU', '2', NULL, NULL, NULL, '201', NULL, NULL, TO_DATE('2012-12-12 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, 'HI200000000000002862', NULL, 'HI200000000000000397', 'HI300000000000000072', '0001V61000000001K6UN', 'CORFERCIALPILOT', '2012-12-12', '68197986', '0001A5100000000588SJ', 'HI300000000000000112', 'HI300000000000000101', NULL, '0001A510000000059CFD', '上海市浦东新区秀沿路1028号108室', '-', NULL, '-', '-', NULL, NULL, '0001A51000000005T8GX', NULL, NULL, '0001A51000000005KZI6', NULL, NULL, NULL, NULL, NULL, NULL, '1044', TO_DATE('2019-01-10 18:00:18', 'SYYYY-MM-DD HH24:MI:SS'), 'N', 'N', 'N', 'N', '1', NULL, '6', '1044AA1000000000006U', '三分部(外籍)（已撤销）', NULL, NULL);

-- ----------------------------
-- Table structure for T_USER
-- ----------------------------
DROP TABLE "CABINAPP"."T_USER";
CREATE TABLE "CABINAPP"."T_USER" (
  "ID" NUMBER(20) NOT NULL ,
  "USERNAME" VARCHAR2(50 BYTE) ,
  "PASSWORD" VARCHAR2(80 BYTE) ,
  "NICKNAME" VARCHAR2(100 BYTE) ,
  "HEADIMGURL" VARCHAR2(200 BYTE) ,
  "PHONE" VARCHAR2(12 BYTE) ,
  "SEX" NUMBER(2) ,
  "ENABLED" NUMBER(2) ,
  "TYPE" VARCHAR2(10 BYTE) ,
  "CREATETIME" DATE ,
  "UPDATETIME" DATE 
)
TABLESPACE "CABINAPP_DATA"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of "T_USER"
-- ----------------------------
INSERT INTO "CABINAPP"."T_USER" VALUES ('1', 'admin', '$2a$10$cqOyLPNNzjt8PYSOAxnpVe4PluwHNvuDpEeAqldENDXPTUEsCpCyi', '管理员', 'http://pz1dwymh0.bkt.clouddn.com/QQ截图20191017222833.png', '13106975707', '1', '1', 'BACKEND', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER" VALUES ('2', 'owen', '$2a$10$4WkpmB1jHncBCrzJ7hJRq.SsiEFiyE/FdgPF26hLs8vzPyoNpZjta', '欧文', 'http://payo7kq4i.bkt.clouddn.com/QQ%E5%9B%BE%E7%89%8720180819191900.jpg', '18579068166', '1', '0', 'APP', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER" VALUES ('3', 'user', '$2a$10$fL/AfD4RDS0LxLJS7zpaZ.YUMfjNWKVvUn7oiA75L1K6PXazSTJPi', '体验用户', 'http://payo7kq4i.bkt.clouddn.com/QQ%E5%9B%BE%E7%89%8720180819191900.jpg', NULL, '1', '0', 'APP', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER" VALUES ('4', 'test', '$2a$10$RD18sHNphJMmcuLuUX/Np.IV/7Ngbjd3Jtj3maFLpwaA6KaHVqPtq', '测试账户', 'http://payo7kq4i.bkt.clouddn.com/QQ%E5%9B%BE%E7%89%8720180819191900.jpg', '13851539156', '0', '0', 'APP', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER" VALUES ('7', 'useruser', '$2a$10$Oar0D2I0yRaGocx71mP2zeKJPEec0bddQRrQsXM3ue52NPKrn5KQq', 'useruser', NULL, '18571111111', '1', '1', 'APP', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER" VALUES ('8', 'abc', '$2a$10$RII9blAhenwoFLjL1Y7kNOgq8xqUR/.o6SCDmfPbb6IAnZng/HsKa', 'abc', NULL, '13322332123', '0', '0', 'APP', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER" VALUES ('9', 'jay', '$2a$10$og3NMep2E4sJF90IzoyVre53A37APaNvbXXTJDhcjQkDuTHIe.wvO', 'jay', NULL, '15151515151', '0', '1', 'APP', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER" VALUES ('10', 'testpre', '$2a$10$ep9ukU/DELSKJHb6vbhUC.CJHFMQAgWCuWMAGLr2vZmIt8yar5EAa', 'testpre', NULL, '17791907897', '1', '1', 'APP', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER" VALUES ('11', '1', '$2a$10$CbVviNMFrg87ThHSUwplauTH28AM/aXFp/0vvuRvi8546OO97W36a', '1', NULL, '13530151800', '1', '1', 'APP', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-30 16:10:48', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER" VALUES ('12', '12', '$2a$10$cgRGZ0uuIAoKuwBoTWmz7eJzP4RUEr688VlnpZ4BTCz2RZEt0jrIe', '12', NULL, '17587132062', '0', '0', 'APP', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER" VALUES ('13', 'abc1', '$2a$10$pzvn4TfBh2oFZJbtagovFe56ZTUlTaawPnx0Yz2PeqGex0xbddAGu', 'abc', NULL, '12345678901', '0', '0', 'APP', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER" VALUES ('14', 'ceshis', '$2a$10$wh0d8dn67WXCH6oNeDW3Q.NnJHiVUjEvLBOVUqjA2F/pn7cIpfjLG', 'ceshis', NULL, '12345643456', '0', '0', 'APP', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-30 13:03:07', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER" VALUES ('15', 'w2121', '$2a$10$NaUk9I7XfcE5x2hkJHhJF.YxWi/pUM51KTYiP1Y74dh5v70SczcLC', '122', NULL, '15854556993', '0', '1', 'APP', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER" VALUES ('1177471727929483265', 'zhongmaokun', '$2a$10$HyOgck/wGd9LAl1zJUU1XewymPHEGNkdY4BPrh89G7TKAsLPDWUTS', 'test_zhong', NULL, '13144445555', '0', '1', 'BACKEND', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER" VALUES ('1177471727929483266', 'lvcyLPQGgFee18C', '$2a$10$OJIVJy18cFMmHk8xKwBlie5lNelRFCXcAByM/GgVN1lZ7E2fhSbA2', 'DO+', 'http://payo7kq4i.bkt.clouddn.com/QQ%E5%9B%BE%E7%89%8720180819191900.jpg', '18571111112', '1', '1', 'APP', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER" VALUES ('1177471727929483267', 'zhuzhu', '$2a$10$uACYqcigXouYI9Zefmffcewi.ajDYWBB2Q8d5V3lhOM3ypvEf3ncC', '猪猪', NULL, '13333333333', '0', '1', 'APP', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER" VALUES ('1177471727929483268', 'zhuzhu2', '$2a$10$/E0B5Hr5bSvc4XU.XQzePeuPMOVnOMQc0uYdd8Oufx82IQgknanLy', 'zhuzhu2', NULL, '12222222222', '0', '1', 'APP', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER" VALUES ('1184725405829824514', 'iot-admin', '$2a$10$U4Rv1BxORF.lISBftymZS./I8AbhPwpfJXnKU1e8nJ7MzyVZt.bDC', 'iot-admin', NULL, '13578977445', '0', '1', 'BACKEND', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER" VALUES ('1185404614952673281', 'bjw', '$2a$10$94H1cZQ565I4tpel3I2T4OJtZTblIIz4cTFxUcRuqfLLif42q6Hf6', 'bjw', NULL, '18679125999', '0', '1', 'BACKEND', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER" VALUES ('1187258548271419393', 'adminUser', '$2a$10$Wtw81uu43fGKw9lkOr1RAOTNWxQIZBsB3YDwc/5yDnr/yeG5x92EG', '用户管理员', NULL, '18801775349', '0', '1', 'BACKEND', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER" VALUES ('1189061301788348418', 'test001', '$2a$10$cqOyLPNNzjt8PYSOAxnpVe4PluwHNvuDpEeAqldENDXPTUEsCpCyi', '试试1', NULL, '18801775321', '1', '1', 'BACKEND', TO_DATE('2019-10-29 14:07:58', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-29 14:08:30', 'SYYYY-MM-DD HH24:MI:SS'));

-- ----------------------------
-- Table structure for T_USER_MENU
-- ----------------------------
DROP TABLE "CABINAPP"."T_USER_MENU";
CREATE TABLE "CABINAPP"."T_USER_MENU" (
  "ID" NUMBER(11) NOT NULL ,
  "PARENTID" VARCHAR2(64 BYTE) ,
  "NAME" VARCHAR2(64 BYTE) ,
  "URL" VARCHAR2(100 BYTE) ,
  "PATH" VARCHAR2(100 BYTE) ,
  "CSS" VARCHAR2(30 BYTE) ,
  "SORT" NUMBER(11) ,
  "CREATETIME" DATE ,
  "UPDATETIME" DATE ,
  "ISMENU" NUMBER(11) ,
  "HIDDEN" NUMBER(11) 
)
TABLESPACE "CABINAPP_DATA"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of "T_USER_MENU"
-- ----------------------------
INSERT INTO "CABINAPP"."T_USER_MENU" VALUES ('1', '-1', '用户中心', 'javascript:;', NULL, 'layui-icon-set', '2', TO_DATE('2019-09-05 11:37:02', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-30 16:48:58', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0');
INSERT INTO "CABINAPP"."T_USER_MENU" VALUES ('2', '1', '用户管理', '#!user', 'system/user.html', 'layui-icon-friends', '21', TO_DATE('2017-11-17 16:56:59', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-31 10:40:17', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0');
INSERT INTO "CABINAPP"."T_USER_MENU" VALUES ('3', '1', '角色管理', '#!role', 'system/role.html', 'layui-icon-friends', '22', TO_DATE('2017-11-17 16:56:59', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-31 10:40:22', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0');
INSERT INTO "CABINAPP"."T_USER_MENU" VALUES ('4', '1', '菜单管理', '#!menus', 'system/menus.html', 'layui-icon-menu-fill', '23', TO_DATE('2017-11-17 16:56:59', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-31 10:40:26', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0');
INSERT INTO "CABINAPP"."T_USER_MENU" VALUES ('5', '1', '权限管理', '#!permissions', 'system/permissions.html', 'layui-icon-password', '24', TO_DATE('2017-11-17 16:56:59', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-31 10:40:35', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0');
INSERT INTO "CABINAPP"."T_USER_MENU" VALUES ('6', '1', '我的信息', '#!myInfo', 'system/myInfo.html', NULL, '25', TO_DATE('2017-11-17 16:56:59', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-31 10:40:47', 'SYYYY-MM-DD HH24:MI:SS'), '1', '1');
INSERT INTO "CABINAPP"."T_USER_MENU" VALUES ('7', '-1', '应用中心', 'javascript:;', NULL, 'layui-icon-set', '1', TO_DATE('2017-11-17 16:56:59', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-30 16:38:53', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0');
INSERT INTO "CABINAPP"."T_USER_MENU" VALUES ('8', '7', '应用授权', '#!app', 'attestation/app.html', 'layui-icon-app', '13', TO_DATE('2017-11-17 16:56:59', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-31 10:40:11', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0');
INSERT INTO "CABINAPP"."T_USER_MENU" VALUES ('9', '7', '应用模块', '#!services', 'attestation/services.html', 'layui-icon-website', '12', TO_DATE('2017-11-17 16:56:59', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-31 10:40:07', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0');
INSERT INTO "CABINAPP"."T_USER_MENU" VALUES ('10', '1', '在线管理', '#!token', 'attestation/token.html', 'layui-icon-util', '26', TO_DATE('2018-09-08 13:19:56', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-31 10:40:54', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0');
INSERT INTO "CABINAPP"."T_USER_MENU" VALUES ('11', '-1', '系统监控', 'javascript:;', NULL, 'layui-icon-set', '3', TO_DATE('2018-08-25 10:41:58', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-30 16:49:08', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0');
INSERT INTO "CABINAPP"."T_USER_MENU" VALUES ('12', '11', '注册中心', '#!register', 'http://106.13.3.200:1111/', 'layui-icon-engine', '31', TO_DATE('2017-11-17 16:56:59', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-31 10:41:02', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0');
INSERT INTO "CABINAPP"."T_USER_MENU" VALUES ('13', '7', '应用治理', '#!eureka', 'eureka/list.html', 'layui-icon-engine', '11', TO_DATE('2018-08-30 15:30:19', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-31 10:40:02', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0');
INSERT INTO "CABINAPP"."T_USER_MENU" VALUES ('14', '11', '慢查询', '#!sql', 'system/sql.html', 'layui-icon-util', '34', TO_DATE('2017-11-17 16:56:59', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-31 10:41:20', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0');
INSERT INTO "CABINAPP"."T_USER_MENU" VALUES ('15', '11', '文件中心', '#!files', 'files/files.html', 'layui-icon-file', '33', TO_DATE('2017-11-17 16:56:59', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-31 10:41:14', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0');
INSERT INTO "CABINAPP"."T_USER_MENU" VALUES ('16', '11', '文档中心', '#!swagger', 'http://106.13.3.200/swagger-ui.html', 'layui-icon-app', '32', TO_DATE('2017-11-17 16:56:59', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-31 10:41:09', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0');
INSERT INTO "CABINAPP"."T_USER_MENU" VALUES ('18', '11', '日志中心', '#!log', 'system/log.html', 'layui-icon-engine', '35', TO_DATE('2019-03-11 06:30:01', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-31 10:41:29', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0');
INSERT INTO "CABINAPP"."T_USER_MENU" VALUES ('19', '11', 'prometheus监控', '#!prometheus', 'http://106.13.3.200:1111', 'layui-icon-engine', '37', TO_DATE('2019-03-27 11:23:31', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-31 14:25:38', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0');
INSERT INTO "CABINAPP"."T_USER_MENU" VALUES ('29', '11', 'redis实时监控', '#!redis', 'monitor/redis.html', 'layui-icon-engine', '36', TO_DATE('2019-10-31 10:42:36', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-31 14:24:52', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0');

-- ----------------------------
-- Table structure for T_USER_ORDER_SEQ
-- ----------------------------
DROP TABLE "CABINAPP"."T_USER_ORDER_SEQ";
CREATE TABLE "CABINAPP"."T_USER_ORDER_SEQ" (
  "SEQ_NAME" VARCHAR2(50 BYTE) NOT NULL ,
  "CURRENT_VAL" NUMBER(11) ,
  "MAX_VAL" NUMBER(11) ,
  "INCREMENT_VAL" VARCHAR2(11 BYTE) 
)
TABLESPACE "CABINAPP_DATA"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of "T_USER_ORDER_SEQ"
-- ----------------------------
INSERT INTO "CABINAPP"."T_USER_ORDER_SEQ" VALUES ('oc_user', '1', '9999', '1');

-- ----------------------------
-- Table structure for T_USER_PERMISSION
-- ----------------------------
DROP TABLE "CABINAPP"."T_USER_PERMISSION";
CREATE TABLE "CABINAPP"."T_USER_PERMISSION" (
  "ID" NUMBER(20) NOT NULL ,
  "PERMISSION" VARCHAR2(50 BYTE) ,
  "NAME" VARCHAR2(50 BYTE) ,
  "CREATETIME" DATE ,
  "UPDATETIME" DATE 
)
TABLESPACE "CABINAPP_DATA"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of "T_USER_PERMISSION"
-- ----------------------------
INSERT INTO "CABINAPP"."T_USER_PERMISSION" VALUES ('1', 'permission:post/permissions', '保存权限标识', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_PERMISSION" VALUES ('2', 'permission:put/permissions', '修改权限标识', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_PERMISSION" VALUES ('3', 'permission:delete/permissions/{id}', '删除权限标识', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_PERMISSION" VALUES ('4', 'permission:get/permissions', '查询权限标识', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_PERMISSION" VALUES ('5', 'role:post/roles', '添加角色', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_PERMISSION" VALUES ('6', 'role:put/roles', '修改角色', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_PERMISSION" VALUES ('7', 'role:delete/roles/{id}', '删除角色', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_PERMISSION" VALUES ('8', 'role:post/roles/{id}/permissions', '给角色分配权限', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_PERMISSION" VALUES ('9', 'role:get/roles', '查询角色', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_PERMISSION" VALUES ('10', 'role:get/roles/{id}/permissions', '获取角色的权限', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_PERMISSION" VALUES ('11', 'user:post/users/{id}/roles', '给用户分配角色', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_PERMISSION" VALUES ('12', 'user:post/users/{id}/resetPassword', '用户重置密码', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_PERMISSION" VALUES ('13', 'user:get/users', '用户查询', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_PERMISSION" VALUES ('14', 'user:put/users/me', '修改用户', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_PERMISSION" VALUES ('15', 'user:get/users/{id}/roles', '获取用户的角色', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_PERMISSION" VALUES ('16', 'user:post/users/saveOrUpdate', '新增用户', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_PERMISSION" VALUES ('17', 'user:post/users/exportUser', '导出用户', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_PERMISSION" VALUES ('18', 'user:get/users/updateEnabled', '用户状态修改', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_PERMISSION" VALUES ('19', 'user:put/users/password', '修改密码', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_PERMISSION" VALUES ('20', 'menu:get/menus/all', '查询菜单', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_PERMISSION" VALUES ('21', 'menu:post/menus/granted', '给角色分配菜单', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_PERMISSION" VALUES ('22', 'menu:get/menus/tree', '树形显示', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_PERMISSION" VALUES ('23', 'menu:get/menus/{roleId}/menus', '获取角色的菜单', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_PERMISSION" VALUES ('24', 'menu:post/menus', '添加菜单', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_PERMISSION" VALUES ('25', 'menu:put/menus', '修改菜单', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_PERMISSION" VALUES ('26', 'menu:delete/menus/{id}', '删除菜单', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_PERMISSION" VALUES ('27', 'menu:get/menus/current', '当前用户菜单', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_PERMISSION" VALUES ('29', 'menu:get/menus/findAlls', '所有菜单', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_PERMISSION" VALUES ('30', 'client:post/clients', '保存应用', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_PERMISSION" VALUES ('31', 'client:get/clients', '应用列表', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_PERMISSION" VALUES ('32', 'client:get/clients/{id}', '根据id获取应用', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_PERMISSION" VALUES ('33', 'clientdelete/clients', '删除应用', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_PERMISSION" VALUES ('34', 'service:get/service/findAlls', '查询所有服务', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_PERMISSION" VALUES ('35', 'service:get/service/findOnes', '服务树', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_PERMISSION" VALUES ('36', 'menu:get/menus/findOnes', '获取菜单以及顶层菜单', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_PERMISSION" VALUES ('37', 'permission:get/permissions/{roleId}/permissions', '根据roleId获取权限', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_PERMISSION" VALUES ('38', 'file:query', '获取文件列表', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_PERMISSION" VALUES ('39', 'file:del', '删除文件', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));

-- ----------------------------
-- Table structure for T_USER_ROLE
-- ----------------------------
DROP TABLE "CABINAPP"."T_USER_ROLE";
CREATE TABLE "CABINAPP"."T_USER_ROLE" (
  "ID" NUMBER(11) NOT NULL ,
  "CODE" VARCHAR2(32 BYTE) ,
  "NAME" VARCHAR2(50 BYTE) ,
  "CREATETIME" DATE ,
  "UPDATETIME" DATE 
)
TABLESPACE "CABINAPP_DATA"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of "T_USER_ROLE"
-- ----------------------------
INSERT INTO "CABINAPP"."T_USER_ROLE" VALUES ('1', 'ADMIN', '管理员', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_ROLE" VALUES ('3', '002', '普通用户', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_ROLE" VALUES ('4', 'pro', '测试权限', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_ROLE" VALUES ('5', 'iot', 'iot', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "CABINAPP"."T_USER_ROLE" VALUES ('6', 'adminUserRole', '用户管理员', TO_DATE('2019-10-28 11:16:00', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2019-11-03 16:08:26', 'SYYYY-MM-DD HH24:MI:SS'));

-- ----------------------------
-- Table structure for T_USER_ROLE_MENU
-- ----------------------------
DROP TABLE "CABINAPP"."T_USER_ROLE_MENU";
CREATE TABLE "CABINAPP"."T_USER_ROLE_MENU" (
  "ROLEID" NUMBER(11) NOT NULL ,
  "MENUID" NUMBER(11) NOT NULL 
)
TABLESPACE "CABINAPP_DATA"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of "T_USER_ROLE_MENU"
-- ----------------------------
INSERT INTO "CABINAPP"."T_USER_ROLE_MENU" VALUES ('1', '1');
INSERT INTO "CABINAPP"."T_USER_ROLE_MENU" VALUES ('1', '2');
INSERT INTO "CABINAPP"."T_USER_ROLE_MENU" VALUES ('1', '3');
INSERT INTO "CABINAPP"."T_USER_ROLE_MENU" VALUES ('1', '4');
INSERT INTO "CABINAPP"."T_USER_ROLE_MENU" VALUES ('1', '5');
INSERT INTO "CABINAPP"."T_USER_ROLE_MENU" VALUES ('1', '6');
INSERT INTO "CABINAPP"."T_USER_ROLE_MENU" VALUES ('1', '7');
INSERT INTO "CABINAPP"."T_USER_ROLE_MENU" VALUES ('1', '8');
INSERT INTO "CABINAPP"."T_USER_ROLE_MENU" VALUES ('1', '9');
INSERT INTO "CABINAPP"."T_USER_ROLE_MENU" VALUES ('1', '10');
INSERT INTO "CABINAPP"."T_USER_ROLE_MENU" VALUES ('1', '11');
INSERT INTO "CABINAPP"."T_USER_ROLE_MENU" VALUES ('1', '12');
INSERT INTO "CABINAPP"."T_USER_ROLE_MENU" VALUES ('1', '13');
INSERT INTO "CABINAPP"."T_USER_ROLE_MENU" VALUES ('1', '14');
INSERT INTO "CABINAPP"."T_USER_ROLE_MENU" VALUES ('1', '15');
INSERT INTO "CABINAPP"."T_USER_ROLE_MENU" VALUES ('1', '16');
INSERT INTO "CABINAPP"."T_USER_ROLE_MENU" VALUES ('1', '18');
INSERT INTO "CABINAPP"."T_USER_ROLE_MENU" VALUES ('1', '19');
INSERT INTO "CABINAPP"."T_USER_ROLE_MENU" VALUES ('1', '29');
INSERT INTO "CABINAPP"."T_USER_ROLE_MENU" VALUES ('4', '1');
INSERT INTO "CABINAPP"."T_USER_ROLE_MENU" VALUES ('4', '2');
INSERT INTO "CABINAPP"."T_USER_ROLE_MENU" VALUES ('4', '11');
INSERT INTO "CABINAPP"."T_USER_ROLE_MENU" VALUES ('4', '13');
INSERT INTO "CABINAPP"."T_USER_ROLE_MENU" VALUES ('5', '1');
INSERT INTO "CABINAPP"."T_USER_ROLE_MENU" VALUES ('5', '2');
INSERT INTO "CABINAPP"."T_USER_ROLE_MENU" VALUES ('5', '3');
INSERT INTO "CABINAPP"."T_USER_ROLE_MENU" VALUES ('5', '4');
INSERT INTO "CABINAPP"."T_USER_ROLE_MENU" VALUES ('5', '5');
INSERT INTO "CABINAPP"."T_USER_ROLE_MENU" VALUES ('5', '6');
INSERT INTO "CABINAPP"."T_USER_ROLE_MENU" VALUES ('5', '26');
INSERT INTO "CABINAPP"."T_USER_ROLE_MENU" VALUES ('5', '27');
INSERT INTO "CABINAPP"."T_USER_ROLE_MENU" VALUES ('6', '1');
INSERT INTO "CABINAPP"."T_USER_ROLE_MENU" VALUES ('6', '2');
INSERT INTO "CABINAPP"."T_USER_ROLE_MENU" VALUES ('6', '3');
INSERT INTO "CABINAPP"."T_USER_ROLE_MENU" VALUES ('6', '4');
INSERT INTO "CABINAPP"."T_USER_ROLE_MENU" VALUES ('6', '5');
INSERT INTO "CABINAPP"."T_USER_ROLE_MENU" VALUES ('6', '6');
INSERT INTO "CABINAPP"."T_USER_ROLE_MENU" VALUES ('6', '28');

-- ----------------------------
-- Table structure for T_USER_ROLE_PERMISSION
-- ----------------------------
DROP TABLE "CABINAPP"."T_USER_ROLE_PERMISSION";
CREATE TABLE "CABINAPP"."T_USER_ROLE_PERMISSION" (
  "ROLEID" NUMBER(11) NOT NULL ,
  "PERMISSIONID" NUMBER(20) NOT NULL 
)
TABLESPACE "CABINAPP_DATA"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of "T_USER_ROLE_PERMISSION"
-- ----------------------------
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('1', '1');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('1', '1');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('1', '2');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('1', '3');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('1', '4');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('1', '5');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('1', '6');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('1', '7');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('1', '8');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('1', '9');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('1', '10');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('1', '11');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('1', '12');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('1', '13');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('1', '14');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('1', '15');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('1', '16');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('1', '17');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('1', '18');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('1', '19');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('1', '20');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('1', '21');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('1', '22');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('1', '23');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('1', '24');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('1', '25');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('1', '26');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('1', '27');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('1', '29');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('1', '30');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('1', '31');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('1', '32');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('1', '33');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('1', '34');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('1', '35');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('1', '36');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('1', '37');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('1', '38');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('1', '39');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('3', '38');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('3', '39');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('4', '34');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('6', '1');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('6', '2');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('6', '3');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('6', '4');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('6', '5');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('6', '6');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('6', '7');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('6', '8');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('6', '9');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('6', '10');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('6', '11');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('6', '12');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('6', '13');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('6', '14');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('6', '15');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('6', '16');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('6', '17');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('6', '18');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('6', '19');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('6', '20');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('6', '21');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('6', '22');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('6', '23');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('6', '24');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('6', '25');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('6', '26');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('6', '27');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('6', '29');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('6', '30');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('6', '31');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('6', '32');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('6', '33');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('6', '34');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('6', '35');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('6', '36');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('6', '37');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('6', '38');
INSERT INTO "CABINAPP"."T_USER_ROLE_PERMISSION" VALUES ('6', '39');

-- ----------------------------
-- Table structure for T_USER_ROLE_USER
-- ----------------------------
DROP TABLE "CABINAPP"."T_USER_ROLE_USER";
CREATE TABLE "CABINAPP"."T_USER_ROLE_USER" (
  "USERID" NUMBER(20) NOT NULL ,
  "ROLEID" NUMBER(11) NOT NULL 
)
TABLESPACE "CABINAPP_DATA"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of "T_USER_ROLE_USER"
-- ----------------------------
INSERT INTO "CABINAPP"."T_USER_ROLE_USER" VALUES ('1189061301788348418', '6');
INSERT INTO "CABINAPP"."T_USER_ROLE_USER" VALUES ('1', '1');
INSERT INTO "CABINAPP"."T_USER_ROLE_USER" VALUES ('2', '1');
INSERT INTO "CABINAPP"."T_USER_ROLE_USER" VALUES ('4', '1');
INSERT INTO "CABINAPP"."T_USER_ROLE_USER" VALUES ('7', '3');
INSERT INTO "CABINAPP"."T_USER_ROLE_USER" VALUES ('8', '1');
INSERT INTO "CABINAPP"."T_USER_ROLE_USER" VALUES ('9', '1');
INSERT INTO "CABINAPP"."T_USER_ROLE_USER" VALUES ('10', '1');
INSERT INTO "CABINAPP"."T_USER_ROLE_USER" VALUES ('11', '1');
INSERT INTO "CABINAPP"."T_USER_ROLE_USER" VALUES ('13', '1');
INSERT INTO "CABINAPP"."T_USER_ROLE_USER" VALUES ('14', '1');
INSERT INTO "CABINAPP"."T_USER_ROLE_USER" VALUES ('15', '3');
INSERT INTO "CABINAPP"."T_USER_ROLE_USER" VALUES ('1177471727929483265', '3');
INSERT INTO "CABINAPP"."T_USER_ROLE_USER" VALUES ('1177471727929483267', '3');
INSERT INTO "CABINAPP"."T_USER_ROLE_USER" VALUES ('1177471727929483268', '4');
INSERT INTO "CABINAPP"."T_USER_ROLE_USER" VALUES ('1177471727929483300', '4');
INSERT INTO "CABINAPP"."T_USER_ROLE_USER" VALUES ('1184725405829824514', '5');
INSERT INTO "CABINAPP"."T_USER_ROLE_USER" VALUES ('1185404614952673281', '1');
INSERT INTO "CABINAPP"."T_USER_ROLE_USER" VALUES ('1187258548271419393', '6');

-- ----------------------------
-- Table structure for t_nc_psnbasdoc1
-- ----------------------------
DROP TABLE "CABINAPP"."t_nc_psnbasdoc1";
CREATE TABLE "CABINAPP"."t_nc_psnbasdoc1" (
  "ID" NVARCHAR2(40) NOT NULL ,
  "PERMANRESIDE" VARCHAR2(40 BYTE) ,
  "ADDR" VARCHAR2(100 BYTE) ,
  "CURADDRESS" VARCHAR2(255 BYTE) ,
  "POSTALCODE" VARCHAR2(40 BYTE) ,
  "EMGCCONTACT" VARCHAR2(10 BYTE) ,
  "EMGCCONTACTPHONE" VARCHAR2(30 BYTE) ,
  "QQ" VARCHAR2(15 BYTE) ,
  "EMP_WECHAT" VARCHAR2(255 BYTE) ,
  "INSOURCE" VARCHAR2(255 BYTE) ,
  "REGULARDATA" VARCHAR2(40 BYTE) ,
  "MAJOR_RANK" VARCHAR2(40 BYTE) ,
  "WORK_PLACE" VARCHAR2(40 BYTE) ,
  "PROTOCAL_BELONG" VARCHAR2(40 BYTE) ,
  "EMPLOEE_RANK" VARCHAR2(40 BYTE) ,
  "JOIN_JX_DATE" DATE ,
  "EMPLOYFORM" VARCHAR2(40 BYTE) ,
  "BEFJOIN_WORKYEAR" VARCHAR2(40 BYTE) ,
  "ACCUM_FUND_ACCOUNT" VARCHAR2(40 BYTE) ,
  "PK_CORP" VARCHAR2(40 BYTE) ,
  "TS" DATE ,
  "ISVALID" VARCHAR2(1 BYTE) ,
  "IS_POSITION" VARCHAR2(1 BYTE) ,
  "IS_EMP_MAN" VARCHAR2(1 BYTE) ,
  "IS_DELETED" VARCHAR2(1 BYTE) ,
  "ROW_NUM" VARCHAR2(10 BYTE) ,
  "EMPLOEE_RANK_NAME" VARCHAR2(10 BYTE) ,
  "SAFE_LEVEL" VARCHAR2(10 BYTE) ,
  "PK_BELONG_DEPT" VARCHAR2(40 BYTE) ,
  "DEPTNAME" VARCHAR2(20 BYTE) ,
  "PHOTO_URL" VARCHAR2(40 BYTE) ,
  "PK_CORP_FIANCE" VARCHAR2(40 BYTE) 
)
TABLESPACE "CABINAPP_DATA"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Sequence structure for AUTOID
-- ----------------------------
DROP SEQUENCE "CABINAPP"."AUTOID";
CREATE SEQUENCE "CABINAPP"."AUTOID" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 CACHE 20;

-- ----------------------------
-- Sequence structure for TABLE1_ID
-- ----------------------------
DROP SEQUENCE "CABINAPP"."TABLE1_ID";
CREATE SEQUENCE "CABINAPP"."TABLE1_ID" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 NOCACHE;

-- ----------------------------
-- Sequence structure for T_USER_MENU_D
-- ----------------------------
DROP SEQUENCE "CABINAPP"."T_USER_MENU_D";
CREATE SEQUENCE "CABINAPP"."T_USER_MENU_D" MINVALUE 28 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 NOCACHE;

-- ----------------------------
-- Sequence structure for T_USER_MENU_ID
-- ----------------------------
DROP SEQUENCE "CABINAPP"."T_USER_MENU_ID";
CREATE SEQUENCE "CABINAPP"."T_USER_MENU_ID" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 NOCACHE;

-- ----------------------------
-- Primary Key structure for table T_OAUTH_CLIENT_DETAILS
-- ----------------------------
ALTER TABLE "CABINAPP"."T_OAUTH_CLIENT_DETAILS" ADD CONSTRAINT "SYS_C00415896" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table T_OAUTH_CLIENT_SERVICE
-- ----------------------------
ALTER TABLE "CABINAPP"."T_OAUTH_CLIENT_SERVICE" ADD CONSTRAINT "SYS_C00415897" CHECK ("CLIENTID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "CABINAPP"."T_OAUTH_CLIENT_SERVICE" ADD CONSTRAINT "SYS_C00415899" CHECK ("SERVICEID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table T_OAUTH_SERVICE
-- ----------------------------
ALTER TABLE "CABINAPP"."T_OAUTH_SERVICE" ADD CONSTRAINT "SYS_C00415900" PRIMARY KEY ("ID");

-- ----------------------------
-- Primary Key structure for table T_USER
-- ----------------------------
ALTER TABLE "CABINAPP"."T_USER" ADD CONSTRAINT "SYS_C00415905" PRIMARY KEY ("ID");

-- ----------------------------
-- Primary Key structure for table T_USER_MENU
-- ----------------------------
ALTER TABLE "CABINAPP"."T_USER_MENU" ADD CONSTRAINT "SYS_C00415902" PRIMARY KEY ("ID");

-- ----------------------------
-- Triggers structure for table T_USER_MENU
-- ----------------------------
CREATE TRIGGER "CABINAPP"."TABLE1_TG_INSERTID" BEFORE INSERT ON "CABINAPP"."T_USER_MENU" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
begin
select t_user_menu_d.nextval into:new.id from dual;
end;
/

-- ----------------------------
-- Checks structure for table T_USER_ORDER_SEQ
-- ----------------------------
ALTER TABLE "CABINAPP"."T_USER_ORDER_SEQ" ADD CONSTRAINT "SYS_C00415901" CHECK ("SEQ_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table T_USER_PERMISSION
-- ----------------------------
ALTER TABLE "CABINAPP"."T_USER_PERMISSION" ADD CONSTRAINT "SYS_C00415903" PRIMARY KEY ("ID");

-- ----------------------------
-- Primary Key structure for table T_USER_ROLE
-- ----------------------------
ALTER TABLE "CABINAPP"."T_USER_ROLE" ADD CONSTRAINT "SYS_C00415904" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table T_USER_ROLE_MENU
-- ----------------------------
ALTER TABLE "CABINAPP"."T_USER_ROLE_MENU" ADD CONSTRAINT "SYS_C00415906" CHECK ("ROLEID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "CABINAPP"."T_USER_ROLE_MENU" ADD CONSTRAINT "SYS_C00415907" CHECK ("MENUID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table T_USER_ROLE_PERMISSION
-- ----------------------------
ALTER TABLE "CABINAPP"."T_USER_ROLE_PERMISSION" ADD CONSTRAINT "SYS_C00415909" CHECK ("ROLEID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "CABINAPP"."T_USER_ROLE_PERMISSION" ADD CONSTRAINT "SYS_C00415910" CHECK ("PERMISSIONID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table T_USER_ROLE_USER
-- ----------------------------
ALTER TABLE "CABINAPP"."T_USER_ROLE_USER" ADD CONSTRAINT "SYS_C00415912" CHECK ("USERID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "CABINAPP"."T_USER_ROLE_USER" ADD CONSTRAINT "SYS_C00415913" CHECK ("ROLEID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table t_nc_psnbasdoc1
-- ----------------------------
ALTER TABLE "CABINAPP"."t_nc_psnbasdoc1" ADD CONSTRAINT "SYS_C00416235" PRIMARY KEY ("ID");

-- ----------------------------
-- Checks structure for table t_nc_psnbasdoc1
-- ----------------------------
ALTER TABLE "CABINAPP"."t_nc_psnbasdoc1" ADD CONSTRAINT "SYS_C00416234" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
